********************************************************************************
*																			   *
*						Sir! I'd Rather Go to School Sir!					   *
*																			   *
*								 Mahdi Majbouri								   *
*																			   *
*									 Table 1								   *
*																			   *
*									6-6-2023								   *
*																			   *
********************************************************************************

*** 
use "census11-all.dta", clear

keep if fage>=fage18 & fage18>=threshold - 9 & fage18<=threshold + 10


********************************************************************************
**  Summary Statistics
********************************************************************************

** sole sons

summ age prim_mid highschool college_plus ///
	if y18 > 2000 & y18 <= 2010 & son == 1 & sons == 1 & college_plus!=. & ///
	father_ed !=. & mom_ed != . & mage !=.

	
** sole sons' sisters	
summ age prim_mid highschool college_plus ///
	if y18 > 2000 & y18 <= 2010 & son == 0 & relate == 3 & sons == 1 ///
	& college_plus!=. & father_ed !=. & mom_ed != . & mage !=.

	
** sons in multiple son households
summ age prim_mid highschool college_plus ///
	if y18 > 2000 & y18 <= 2010 & son == 1 & sons > 1 & college_plus!=. & ///
	father_ed !=. & mom_ed != . & mage !=.

** daughters in multiple son households	
summ age prim_mid highschool college_plus ///
	if y18 > 2000 & y18 <= 2010 & son == 0 & relate == 3 & sons > 1 ///
	& college_plus!=. & father_ed !=. & mom_ed != . & mage !=.
	

	
** All Men and Women Aged 19 to 28	
use "census20-28.dta", clear
** men aged 19-28
summ age prim_mid highschool college_plus if sex == 1

** women aged 19-28
summ age prim_mid highschool college_plus if sex == 2
	
	
********************************************************************************
*********************************  THE END *************************************
********************************************************************************
